<%@ page import="java.util.ArrayList" %>
<%@ page import="java.util.List" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="edu.sctu.User" %>
<%@ page import="edu.sctu.Database" %><%--

  Created by IntelliJ IDEA.
  User: Lenovo
  Date: 2018/5/17
  Time: 15:37
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>$Title$</title>
</head>
<body>

<style type="text/css">

    table{
        border-collapse: collapse;
    }
    td{
        border:  1px solid #000;
        padding:10px;

    }
</style>

<table>
    <tr>
        <td>编号</td>
        <td>用户名</td>
        <td>密码</td>
        <td>操作1</td>
        <td>操作2</td>
    </tr>
    <%

        Database database=new Database();
        List<User>userList=database.getUserList();


        request.setAttribute("userList",userList);

    %>

    <c:forEach  var="user" items="${userList}">
        <tr>
            <td>${user.id}</td>
            <td>${user.username}</td>
            <td>${user.password}</td>
            <td><a href="">删除</a></td>
            <td><a href="">更新</a></td>

        </tr>
    </c:forEach>

</table>



</body>
</html>



